/*     */ package com.qmsk.business.member.memberIntegralBill.dao;
/*     */ 
/*     */ import com.qmsk.business.sys.basic.SupportDAO;
/*     */ import com.utils.gson.in.GsonHeadManyRows;
/*     */ import com.utils.gson.in.GsonHeadOneRow;
/*     */ import com.utils.gson.out.GsonEbRst;
/*     */ import java.sql.SQLException;
/*     */ import java.util.Date;
/*     */ import java.util.HashMap;
/*     */ import java.util.Map;
/*     */ 
/*     */ public class MemberIntegralBillDao extends SupportDAO
/*     */ {
/*     */   public int insertBsBillInAmt(String billNo, Long memberId, Long shopId, Integer intAmt, Long cashRuleID, String inFrom, Integer mberVday, String slName, Object bissId, String memo)
/*     */     throws SQLException
/*     */   {
/*  18 */     Object[] sparams = { memberId, shopId, billNo, intAmt, 
/*  19 */       cashRuleID, inFrom, mberVday, slName, bissId, memo };
/*  20 */     return update("insertBsBillInAmt", sparams);
/*     */   }
/*     */ 
/*     */   public int insertBsBillInAmtOfService(String billNo, Long memberId, Long shopId, Integer intAmt, Long ruleID, String inFrom, Integer mberVday, String slName, Object bissId, String memo)
/*     */     throws SQLException
/*     */   {
/*  26 */     Object[] sparams = { memberId, shopId, billNo, intAmt, 
/*  27 */       ruleID, inFrom, mberVday, slName, bissId, memo };
/*  28 */     return update("insertBsBillInAmtOfService", sparams);
/*     */   }
/*     */ 
/*     */   public GsonHeadOneRow getRefundSingle(Object bissId) throws SQLException {
/*  32 */     Object[] params = { bissId };
/*  33 */     return getOneRowOfParams("selectSqlRefundSingle", 
/*  34 */       "selectJsonRefundSingle", params);
/*     */   }
/*     */ 
/*     */   public int getIntrOfBillNo(String billNo)
/*     */     throws SQLException
/*     */   {
/*  45 */     Object[] params = { billNo };
/*  46 */     return queryForInt("getIntrOfbillNo", params, Integer.valueOf(0)).intValue();
/*     */   }
/*     */ 
/*     */   public String getMaxBillNo(Object shopId) throws SQLException {
/*  50 */     return getSpTableFieldDayNoShopId("BillNo", shopId);
/*     */   }
/*     */ 
/*     */   public GsonHeadManyRows getIdOfBussNo(String billNo)
/*     */     throws SQLException
/*     */   {
/*  61 */     Object[] params = { billNo };
/*  62 */     return getManyRowsOfParams("getIdOfBillNo", params);
/*     */   }
/*     */ 
/*     */   public Integer checkExistBy(Integer idYy, Long memberId) throws SQLException {
/*  66 */     Map params = new HashMap();
/*  67 */     params.put("ruleId", idYy);
/*  68 */     params.put("memberId", memberId);
/*  69 */     return queryForInt("checkExistBy", params, Integer.valueOf(0)); }
/*     */ 
/*     */   public Integer checkExistByName(String idYy, Long memberId) throws SQLException {
/*  72 */     Map params = new HashMap();
/*  73 */     params.put("name", idYy);
/*  74 */     params.put("memberId", memberId);
/*  75 */     return queryForInt("checkExistByName", params, Integer.valueOf(0)); }
/*     */ 
/*     */   public Integer checkExistByNameOneDay(String idYy, Long memberId) throws SQLException {
/*  78 */     Map params = new HashMap();
/*  79 */     params.put("name", idYy);
/*  80 */     params.put("memberId", memberId);
/*  81 */     return queryForInt("checkExistByNameOneDay", params, Integer.valueOf(0));
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonlOfmemberId(Map<String, Object> params, Integer nPageIdx, Short nPageSize) throws SQLException {
/*  85 */     return getGsonOfParams("selectSqlOfmemberId", params, nPageIdx, nPageSize, false); }
/*     */ 
/*     */   public GsonEbRst getgetIntegral(Map<String, Object> params) throws SQLException {
/*  88 */     return getGsonOfParams("getIntegral", params, false);
/*     */   }
/*     */ 
/*     */   public Integer getWeekRank(String openId) throws SQLException {
/*  92 */     Map params = new HashMap();
/*  93 */     params.put("openId", openId);
/*  94 */     return queryForInt("weekRank", params, null);
/*     */   }
/*     */ 
/*     */   public Integer getallRank(String openId, Long shopId) throws SQLException {
/*  98 */     Map params = new HashMap();
/*  99 */     params.put("openId", openId);
/* 100 */     params.put("shopId", shopId);
/* 101 */     return queryForInt("allRank", params, null);
/*     */   }
/*     */ 
/*     */   public Integer getAllAmt(String openId, Long shopId) throws SQLException {
/* 105 */     Map params = new HashMap();
/* 106 */     params.put("openId", openId);
/* 107 */     params.put("shopId", shopId);
/* 108 */     return queryForInt("allIntAmt", params, Integer.valueOf(999));
/*     */   }
/*     */ 
/*     */   public GsonHeadOneRow getWeekAmt(String openId, Long shopId) throws SQLException {
/* 112 */     Map params = new HashMap();
/* 113 */     params.put("openId", openId);
/* 114 */     params.put("shopId", shopId);
/* 115 */     return getOneRowOfParams("weekAmt", params);
/*     */   }
/*     */ 
/*     */   public int insertIntegralBill(Long memberId, Long shopId, String billNo, Long ruId, Integer intAmt, String intFrom, Date crTime, String userName, int status, String billForm, String memo)
/*     */     throws SQLException
/*     */   {
/* 121 */     Object[] params = { memberId, shopId, billNo, ruId, intAmt, 
/* 122 */       intFrom, crTime, userName, Integer.valueOf(status), billForm, memo };
/* 123 */     return update("insertIntegralBill", params);
/*     */   }
/*     */ }

/* Location:           C:\Users\Administrator\Desktop\新建文件夹\WEB-INF\classes\
 * Qualified Name:     com.qmsk.business.member.memberIntegralBill.dao.MemberIntegralBillDao
 * JD-Core Version:    0.5.3
 */